Executive Summary - Wake County, North Carolina - Real Estate Property Values from 1990 - 2020 4


Here is an executive summary of how your project would look like:



Troubles that occurred during the project:



1.  Data size

The dataset was over 170 MB in size and it was from 1956 to 2020.  Due to the number of years, there was 60+ years of data.  Also, the earlier years of the data, there were not too many sales.  I had to decide what year to start analyzing the data, so I started from 1990.

In order to reduce the size of the dataset ,I also had to split the dataset into small datasets/tables.

Once I had split the dataset, I set up relationships:



2.  Getting the total of apartment units and total heated units

There could be a single Real Estate ID listed multiple times, showing the same sale price, same sale date. However, different number of units, different heated area size.  For example, if an apartment complex is sold, there could be apartment blocks of different sizes, different number of units and on multiple street addresses.  All on one Real Estate ID.  Thus, it was challenging to calculate the the number of units and the total heated area.

To resolve this issue, I used the DAX formula, SUMMARIZECOLUMNS.






To find out more about Executive insights, check out one of Microsoft's partners, Decisive Data:


Decisive Data - Executive Insights